go
insert into authors values('AU000','Null')
insert into authors values('AU001','Joanne Rowling')
insert into authors values('AU002','Kenneth Grahame')
insert into authors values('AU003','Graham Robb')
insert into authors values('AU004','Julian Barnes')
go 
insert into suppliers values('PHO','Phoenix Color Corp','(555) 443.3220','','Liverpool,England')
insert into suppliers values('MAL','Malloy Inc','(555) 553.3245','','Manchester,England')
insert into suppliers values('COU','Courier Corp','(555) 983.2345','','London,England')
insert into suppliers values('FRI','Friesens Corp','(555) 233.8791','','Newcastle,England')
go
insert into categories values('B1',N'Books','')
insert into categories values('M2',N'Magazine','')
insert into categories values('F3',N'Paper Files','')
insert into categories values('C4',N'CD s','')
insert into categories values('D5',N'DVD s','')
insert into categories values('U6',N'Utilities','')
go
insert into brands values('BK0','B1',N'AudioBooks')
insert into brands values('BK1','B1',N'Business & Money')
insert into brands values('BK2','B1',N'Computing & Internet')
insert into brands values('BK3','B1',N'Cookbooks, Food & Wine')
insert into brands values('BK4','B1',N'Diet & Health')
insert into brands values('BK5','B1',N'Entertainment')
insert into brands values('MZ0','M2',N'Animals & Pets')
insert into brands values('MZ1','M2',N'Art & Entertainment')
insert into brands values('MZ2','M2',N'Business & Finance')
insert into brands values('MZ3','M2',N'Computer')
insert into brands values('PF0','F3',N'Tag Files')
insert into brands values('PF1','F3',N'Printed Card Files')
insert into brands values('PF2','F3',N'Business & Finance')
insert into brands values('CD0','C4',N'Readable & Writable')
insert into brands values('CD1','C4',N'Readable')
insert into brands values('DV0','D5',N'Action Movies')
insert into brands values('DV1','D5',N'Animation')
insert into brands values('DV2','D5',N'Children')
insert into brands values('UT0','U6',N'Pen')
insert into brands values('UT1','U6',N'Pencil')
insert into brands values('UT2','U6',N'Paper')
insert into brands values('UT3','U6',N'Sketches')
go

